SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042430 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042430 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508060,1020884,471660,407293,861349,894152,260034,968506,990213,6751,638776,273131,753861,447022,316196,59732,459542,1038761,465937,650910,854426,827802,739129,946156,1039621,878302,110165,874244,903282,70732,848790,865396,958390,400065,309834,4535,612849,593370,163435,241682,302142,317727,1016937,930886,629291,546307,207898,701511,437037,714109,469478,166343,370948,563819,710320,431194,757730,196587,727816,713706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]