SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401754 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401754 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285472,644749,251031,296466,179685,1041555,533499,224844,625571,13444,377466,152349,110573,659479,299444,742284,143583,657470,844650,718722,312256,632961,1044662,788337,155729,1035191,328176,958551,588452,141118,340407,242642,655704,555329,820927,229578,12350,489575,901793,59563,445464,313132,494702,680241,782509,484778,676714,910994,106942,946921,272711,726356,821931,254885,257633,660739,901024,366344,497420,973082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]