SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507840 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507840 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384176,259312,626972,598384,220301,745477,853280,130758,806117,752236,550892,610178,664190,437949,421511,982925,572000,146411,81009,299870,477505,818753,265282,890855,223381,99038,88139,955413,650738,919195,551838,38272,310986,747087,610469,737878,754127,1033578,570837,336226,525420,930982,216647,18904,48633,288403,855201,1036820,1026116,313037,156505,945166,559640,941709,586145,346889,236021,630622,450985,340930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]