SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286840 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286840 [ RunTime:0.003474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432528,213979,540199,696772,320721,422302,382768,221534,259743,361343,311552,271247,813867,749629,663513,869150,230814,610989,37878,891260,895645,573534,30511,15896,905810,586623,179954,137682,735780,806113,635975,492649,941101,621648,686719,609288,857945,28215,425587,692582,48955,431888,217794,429254,933667,813124,181844,16942,462545,261429,319777,540762,941046,947994,468523,58568,973404,495988,574306,674278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]