SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500823 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500823 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102560,849357,351317,103132,40882,282876,567720,311678,334889,405901,578215,548654,260957,249723,685324,228382,17548,804843,165724,405094,832060,271686,280265,749410,574793,779219,756584,856007,248282,1014394,988953,733689,937574,865361,637025,494857,1010018,755456,77634,3000,179124,40354,553414,828572,717987,627055,108646,102382,321590,682807,96997,737206,475958,651045,1014546,576938,850494,455195,546049,146826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]