SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457438 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457438 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5773,160147,219302,45056,765990,104001,486991,58825,952782,105734,791537,18209,233639,818316,180741,269821,805144,159445,839256,126318,13597,480293,925723,605517,779197,841286,207899,794707,647096,255792,81205,474548,415836,948400,475113,212242,454877,752938,833844,958483,655400,286508,318676,893386,981676,734359,783531,197508,452459,1005860,532337,529161,803738,373744,674536,193683,80127,666760,43210,69488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]