SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294776 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294776 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313291,944838,1032994,890868,18054,438002,36531,1027719,741364,992229,651779,656020,374898,189805,234703,628245,1033027,686157,416383,373404,797481,50633,455646,314314,746940,235064,77281,790538,53541,435216,838996,581855,992692,871223,125286,74782,785663,633767,542922,896359,679204,984086,232116,876867,914526,998659,356682,1042111,175555,1025968,423647,118226,520725,80182,758514,441717,253084,433425,987874,798272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]