SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 661583 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 661583 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55016,463806,430983,915573,499742,702595,985359,1001846,565151,147721,296827,376874,246301,180870,298751,150332,1046088,75719,95036,74962,203389,120484,329583,696687,286505,131752,223531,28977,247261,924319,418818,1015842,161256,237533,839005,746732,1009172,917186,1002984,219876,318441,595179,387939,434294,710047,761151,122540,559960,203267,409214,929680,370319,76902,842366,219029,1023412,971837,179977,414321,963852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 661583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 661583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]