SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027096 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027096 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991939,493166,866150,333065,338813,702288,227715,124461,662195,384771,14153,862724,927455,384936,1003624,134336,48069,230133,167709,939461,1027836,593087,1003352,398531,553045,644370,75757,27632,484926,775402,274351,444481,376275,164165,972450,256775,541898,838334,709714,599566,676141,407587,472377,76353,851770,214421,229729,476137,304379,242018,624780,1028136,121019,688885,1008982,464556,96421,640021,918006,299097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]