SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532527 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532527 [ RunTime:0.004400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647873,656823,885302,72826,538850,36883,426931,761456,557503,403313,1035305,461500,341075,839262,637768,172936,218300,411750,494437,201703,423671,225827,972250,723043,587412,665222,390434,428721,588885,326693,991110,880691,1001212,323416,1000047,824060,703758,406819,567753,798107,999613,835761,638810,815106,847596,358709,326780,541657,872914,40610,547442,804246,586597,243701,279386,710997,991310,538521,288024,408413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]