SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010142 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010142 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339675,713407,687867,353250,68136,11266,333550,489845,935946,274259,371602,385831,691410,91477,534568,382674,122124,587846,534678,26990,30351,886227,337655,203228,176479,128224,255451,342917,893549,486203,290828,469191,679704,170312,921228,956649,326819,368093,145977,431657,432442,792057,60344,551166,764961,688972,661028,356228,745676,942686,704149,375547,825546,7310,776128,349663,579356,776599,73431,490621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001200s ]