SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205542 LIMIT 1 [ RunTime:0.000972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205542 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41069,145441,586677,210312,963247,762999,1002385,166846,760021,476568,164330,457885,932472,132711,536246,881093,978138,316413,770000,199442,388322,945188,722981,1040740,511151,356042,875873,431156,466965,524199,611271,501472,493455,674810,690133,622145,216109,499208,785329,849033,764997,864204,636287,374529,951247,658772,951333,140554,566700,637579,622588,157347,203395,93115,165150,1033413,700107,506540,951573,969639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]