SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42683 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42683 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493345,552019,931854,181327,987840,165377,206106,487440,361109,738553,342035,463175,528698,306876,661723,178396,453268,82161,811384,909266,469789,279749,23485,484918,734393,761974,164111,771524,744385,172961,361786,947705,451385,296092,562716,988082,529433,203511,430608,34343,496501,19337,382731,873893,525820,717875,250230,988482,776885,20695,309057,754755,781011,236023,852004,965150,770948,731737,635026,605307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002534s ]