SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26143 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26143 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778380,191106,927110,910897,531866,226821,113224,347777,118693,160885,698944,966742,7900,231686,840178,793244,273304,377888,90384,523282,548671,892154,179421,1012675,656881,408754,441389,987592,1021292,732326,399267,442231,191142,671031,418361,453463,777106,443453,78281,485892,956814,989232,74804,570492,642286,351027,283975,279695,521063,618922,238782,899380,234572,617409,570890,521680,954029,1025687,471069,540169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001932s ]