SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531818 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531818 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612970,440352,920275,646765,945603,273865,451324,199794,545917,412608,404703,869072,781826,548746,504384,770409,221688,60865,767273,715092,663010,48507,875824,102606,869336,955010,380541,495225,242973,850085,660312,735081,430101,670821,443548,844724,78589,141836,598652,520976,216874,922071,31029,415068,780476,133843,155943,590915,1031702,584644,950946,630039,1036215,959804,116127,429471,1045245,606920,769630,321263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]