SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196809 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196809 [ RunTime:0.001103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536457,307228,973568,2929,561194,194429,198718,308140,666018,153177,501634,753026,655012,95790,480066,641768,701420,194523,68018,605440,94462,43760,121286,441036,506162,735844,420628,1012304,787851,776199,350136,434487,912193,1035823,434335,394426,278911,837740,413949,1001847,949634,305496,1046385,579594,865978,134966,189826,401238,524034,818737,319390,796149,401819,261648,321219,410641,590880,191621,149717,721816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]