SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570251 LIMIT 1 [ RunTime:0.001371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570251 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323210,867699,15694,446866,575315,24892,179388,396298,596133,83419,237130,93106,748223,246729,882291,882333,153844,526118,443524,108742,962890,549536,427002,840110,482678,946537,148183,120238,917407,519379,205319,207788,489900,685904,127179,793513,537283,292626,737721,211205,336462,845000,280907,632304,1004431,699624,673172,1001017,240713,762298,970217,535526,921679,804403,305799,791724,775577,268961,722974,533820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002265s ]