SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404529 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404529 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527389,967146,322737,768184,616763,796387,50173,565595,982329,820963,481974,505426,138002,653621,101113,253981,470973,865808,646049,946759,881281,815927,1022239,223893,124814,146835,25275,787971,927826,658931,154424,251234,467486,609871,405243,183153,515291,990146,722087,709333,412568,1006362,986968,528209,397459,361441,144363,741480,107734,1008860,485414,766592,89730,61850,572646,823211,177832,634085,295438,195462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]