SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323574 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323574 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400567,214374,504346,264280,151920,562412,790145,533615,570120,138014,1032309,882178,115381,785901,707995,150188,656165,140320,154953,391563,253036,482594,193056,745214,373713,539624,55641,625563,435791,874239,910659,90207,790997,916682,1027872,100860,317170,239227,52029,746449,790703,755326,324144,1009795,990847,1023569,604528,519085,284856,698698,300006,49912,846839,698009,493600,909476,796194,30838,477526,38402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]