SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464012 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464012 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61737,13110,505438,669348,301439,1011285,1044603,767536,614355,949528,1003513,738230,10335,619738,619356,736563,81173,377941,40424,391282,547016,480087,856761,637761,321822,466902,480643,1044335,351736,267986,326864,707584,974861,40525,945431,704510,703537,505724,38904,873799,222978,159805,1036584,226769,516724,117693,954985,407434,545540,277467,16339,561927,961386,635454,115527,107803,125169,854890,572084,509801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]