SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56427 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56427 [ RunTime:0.004874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18904,395245,588783,1008800,611993,247941,1021247,239465,1021516,421903,158354,840148,75039,463039,187328,103937,28102,687748,673874,637568,646019,724213,598327,252424,778946,1033319,147979,963042,86494,1026309,154551,385028,269635,861927,635773,891072,134835,422833,944240,829707,705578,549406,628938,816619,632660,256284,338197,792249,136859,714785,11176,163323,1047411,791499,145054,320771,384695,169575,42036,196873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]