SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331994 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331994 [ RunTime:0.002708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34449,305254,786933,369414,503297,614944,178632,489081,236272,381731,584413,362336,124150,532303,143802,362931,583828,1029919,194028,547005,710190,54869,450106,237443,978128,639269,712082,230033,805794,149850,442744,970764,865428,1035148,952801,904352,319315,736347,9390,1048535,160872,100276,925237,983743,584758,883631,421043,456510,904989,567190,379801,943925,699235,943875,905970,894428,349521,357068,380414,269911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]