SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595001 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595001 [ RunTime:0.003443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933579,377250,833116,444970,953634,117941,842047,599797,1012221,532583,207754,720704,349244,379506,444781,135077,86407,483334,169259,35883,494797,985886,283103,316731,202233,309061,1026596,1036752,198613,761094,39860,534528,322604,515854,518869,981899,395765,613301,292121,112907,750596,111235,486030,4394,355825,190571,334678,749703,770241,1008450,1045077,168529,35726,241062,883265,334202,847712,117590,691368,813202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]