SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415120 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415120 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974362,554142,66327,717972,914417,629363,1010583,218850,283403,369413,541465,961708,617065,983300,788661,232472,688413,283132,116300,596679,919224,110570,12631,375047,565140,890558,992939,145043,401781,341221,574549,102821,547608,412547,882600,969276,945386,164696,566930,436118,168046,924163,687337,938298,1023010,99866,738378,273133,963789,779074,591004,504561,751892,388370,627221,122271,553737,423253,130281,869048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000814s ]