SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396601 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396601 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721300,421000,416677,752141,153989,726020,112281,82014,815737,538085,160832,211721,939015,186189,721967,609161,577866,243876,1032473,646758,43439,93375,125762,1003052,686798,525838,856329,59095,320163,32244,1023294,911147,566633,230284,630656,67262,307070,605080,529371,37984,779505,867884,1044245,550653,69835,270715,468696,242112,703933,397582,435037,957355,759323,311248,85880,540522,366672,638352,675400,479364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]