SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 798813 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 798813 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316510,887545,592349,475303,266954,120599,385177,185225,427520,230418,406147,46611,456002,441299,169078,79706,687239,303247,194122,822374,116329,327360,723428,561574,941183,607880,126479,86666,658080,524463,607024,447828,218709,405435,1028665,860174,780842,995324,142137,957416,579865,550002,540757,504644,776000,505477,179851,142785,833878,564744,253373,404543,845116,733360,1012113,293100,336487,27841,590270,365380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 798813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 798813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]