SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807294 LIMIT 1 [ RunTime:0.000807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807294 [ RunTime:0.004396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17949,374200,679011,633540,211825,322173,1042025,334393,1017162,649350,705396,250425,843486,543827,320800,338108,614957,971579,334826,136323,263888,799618,784281,551159,79838,743680,365730,289335,875895,928441,987222,720758,478920,936433,454602,423078,649546,450714,902992,549034,607001,705570,798309,765734,562694,354193,511042,455184,179252,102567,9421,553782,341862,250343,124274,99385,930503,65740,344215,403452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]