SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541147 LIMIT 1 [ RunTime:0.003704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541147 [ RunTime:0.008703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885102,982045,383735,228457,369880,932913,259647,728718,224576,135835,100180,23757,462244,176208,619701,200119,7623,609924,663866,409560,182314,528638,475220,195608,44201,108084,655056,521078,689355,357586,382984,324637,926680,49171,360366,304096,85182,757511,632321,967208,550716,893387,388478,246605,446453,248681,809284,289679,438927,1036697,823250,191223,730728,994616,395133,651408,989234,348375,732712,777649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001138s ]