SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501376 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501376 [ RunTime:0.003909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58040,226735,773569,26013,574906,400013,770575,658890,970591,1020945,46991,519830,497489,152353,606802,749951,581554,360181,111819,60378,734966,696104,805039,258111,898076,286403,899644,188119,837115,289709,102373,287011,590553,501029,261019,982103,917643,14816,530146,1021140,192267,597767,500526,389926,392831,561687,350469,696518,592308,299965,480644,212709,178381,984065,151709,628803,645568,285838,222035,1042880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]