SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014506 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014506 [ RunTime:0.002284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664931,201837,806924,1022345,103643,89986,20096,418991,900409,368621,748936,447055,143947,592426,30214,940677,13439,518242,774556,648904,531098,456677,736863,216243,554572,426130,1027648,42310,782799,1043863,856642,26121,24943,767756,655405,8150,513670,871103,989639,262046,411726,360365,406472,631320,745277,937225,152698,370903,917713,331004,1002146,571363,286672,424312,391398,678765,396265,834237,811749,847189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001197s ]