SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383191 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383191 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198997,430957,124494,984096,606186,939729,794548,574338,72105,556486,968491,539749,1043917,1042193,352313,390425,275450,13454,583094,727010,875763,758185,832002,656731,246469,703663,793223,609969,787141,73323,175809,1014373,87077,399954,1016814,982887,901835,323439,276540,732025,318972,68118,403498,677150,284229,667626,882467,943743,713569,73627,658062,401051,996340,893680,753444,950392,237176,136857,181712,729289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]