SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031449 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031449 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112989,548001,187447,336981,940221,255130,793035,149239,1004768,466065,879852,645695,738095,145995,403883,934465,163970,262644,197753,336047,390556,849654,298140,213871,779042,597173,887892,128492,818670,162752,995283,819038,40378,101576,585904,952748,960549,879600,119718,16305,749107,244614,475183,1025415,232325,596791,917561,212635,662262,739950,98654,952711,12630,101818,1020336,625543,914734,806285,437934,395910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]