SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294169 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294169 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040933,462726,14546,664120,350452,267263,102051,596190,3468,882345,892446,291434,14390,228699,688912,1016946,966236,935951,930356,883837,565183,415131,507665,880151,34291,343347,996786,879185,366045,246674,824458,245040,729152,546759,554392,122543,425961,776654,149098,670900,376787,490599,635245,485550,418582,517852,250961,391522,414506,1048859,705009,433980,8242,651784,639451,342199,302444,715272,937219,868545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]