SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010476 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010476 [ RunTime:0.002966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356662,519201,397760,665667,393738,788136,53327,255932,922265,743580,545014,830524,363824,149378,850354,8382,274729,262016,984688,339517,898110,455775,627481,471324,610748,98137,542479,614981,309509,875616,1006020,932715,25452,98176,33541,312617,574914,684010,707179,6649,758295,177109,6832,312550,508797,937460,478375,857960,663254,917804,279061,551394,439104,278140,632621,569368,941891,348563,640716,453812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]