SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420453 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420453 [ RunTime:0.005377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508891,947450,206883,53099,278252,269551,67699,908949,570629,269179,883991,751409,732342,469145,1015269,527641,48183,102809,611236,238409,178784,418232,635674,218883,309505,965486,468152,77090,79531,482744,643655,882522,10625,4445,411107,1008204,708347,448483,831539,957127,229178,488263,37601,962809,35834,785403,415694,646902,737397,566885,971545,45436,333242,304831,431024,393483,212695,533197,114569,348750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]