SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574499 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574499 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027417,182583,338700,161653,496370,242454,484540,955120,720914,1023010,789369,22743,412030,713246,433435,1048170,648593,235213,274971,494314,315632,695591,858556,481986,310722,265696,595212,223879,986162,577757,155321,675390,835813,728731,94552,46040,635246,755619,963132,235049,112796,512431,908146,982301,908510,665203,1013913,970878,12843,398921,548240,701996,595923,952383,109119,605343,900597,707387,712140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]