SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414207 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414207 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415285,1014714,448919,126740,764118,260137,747138,925854,748078,354414,654295,453415,387878,896269,751700,338071,689173,509599,998058,978648,477514,52628,1012281,851869,285113,1037804,696071,555108,670535,37483,254029,501334,784907,705843,890241,778024,199899,83725,206227,817927,738165,136270,1016516,750569,594110,46900,923708,404344,167436,544248,106773,993239,485567,455990,436594,541484,461701,505349,1036203,7314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]