SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502970 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502970 [ RunTime:0.003341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217509,750594,743283,31300,984438,355733,626308,960064,757638,372817,404304,256953,658042,923698,997754,769588,890982,191899,224414,420964,532485,385796,129700,373955,271935,479216,966920,219917,472056,1017937,456929,999172,311379,180479,570609,302723,34209,735458,453591,373900,1039007,430546,911674,899349,457923,705012,843958,472201,987863,981368,834922,320288,620708,958689,83893,842555,156137,313909,396814,1013583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]