SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017688 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017688 [ RunTime:0.003479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149273,483741,390729,164760,1021383,450221,361703,148161,326522,441009,129095,992940,806540,792881,848024,1033319,617749,668001,529052,918316,799680,740172,119284,384830,219369,147265,738291,817143,970193,862172,987923,196790,282685,688103,635993,832072,601417,1037115,588493,558858,146614,618644,841949,964035,807716,756240,707078,168203,52571,426878,1005207,563328,615679,686290,224319,189537,49805,1027817,252935,171965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001942s ]