SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135688 LIMIT 1 [ RunTime:0.001877s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135688 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551468,501934,210964,950154,868877,60569,664750,353059,800079,651408,709002,110850,689539,841088,788808,118674,477835,76054,854818,155118,832542,466915,168052,781368,808286,43525,971441,116429,992927,251505,257803,955527,949655,487668,541974,773232,672161,247551,339314,437477,525682,828216,594297,565532,895677,36491,203397,740432,385254,860103,240581,28511,591879,376217,758684,1001749,398036,719201,409174,559393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]