SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508112 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508112 [ RunTime:0.003832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665967,868427,644631,954368,189644,553588,284659,58346,811390,704057,328952,483683,279722,84499,706883,62995,141942,462159,411078,194437,598206,351688,289679,37865,912004,895209,415161,462364,19982,539030,173385,382505,1031239,382193,523062,41659,863161,825774,1028926,741540,493468,398744,864406,997498,689012,605225,161203,279297,964201,863681,990945,537939,251184,199785,276888,477296,382878,619715,811415,310034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]