SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017711 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017711 [ RunTime:0.003095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536943,370748,295282,307005,681717,187542,863751,838553,454450,753643,276870,404231,912854,162190,743609,817628,753973,1041202,387985,915818,292047,601803,553095,407183,619386,702991,1004217,151082,779772,165754,781881,214079,994685,860132,341245,258994,712622,871091,802418,180538,536870,635824,867684,1004434,489095,387005,555147,30665,575664,49548,840793,1001399,341619,405675,611734,860238,445852,569358,991386,751305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000852s ]