SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400641 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400641 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783254,837362,925635,637405,74252,58064,490115,474711,241475,100545,666533,18369,29329,175386,275657,568632,1044860,290929,842456,391222,198127,268290,826856,638694,270958,447382,42010,889453,77521,225943,787313,666017,569688,553835,928306,362929,813596,758820,31819,169836,176425,461613,748701,178855,484792,912477,993506,652983,245378,423413,542898,414578,755583,164195,995383,1047102,221333,737078,725988,966753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]