SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512249 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512249 [ RunTime:0.003056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707076,86410,404633,992538,436387,957620,1004734,825130,349206,329709,144163,499260,188310,893092,997291,1039544,954618,98977,43658,916940,132112,299426,104951,766793,129581,206218,972325,592613,779376,828588,844935,787003,566511,468602,846509,383105,283109,863123,233082,159888,41748,635710,869632,41126,291672,993941,612111,448677,250288,398068,602071,153874,505424,1007512,734492,402589,658289,32561,905726,61479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]