SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803781 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803781 [ RunTime:0.003457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708873,629095,571352,721876,686544,456215,384162,254593,326914,396329,928672,734449,981953,385008,661550,981641,14505,966797,852753,846949,105912,615971,550196,1028011,1011696,188303,541576,846110,527924,493346,572989,823827,114852,912758,637837,50442,1031633,633878,575271,407482,231777,577017,92087,1026487,1403,967942,764675,917054,532846,867391,67554,603557,853730,883529,364175,716549,402573,1028273,269324,728435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004246s ]