SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531291 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531291 [ RunTime:0.003184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180148,354660,636023,136772,191842,823846,895903,953140,385814,806232,709562,797091,928088,809025,395167,232810,148682,368424,457201,225275,338413,678493,95658,647433,501558,353462,198957,484637,172799,549094,311218,499263,99745,173319,29549,627629,681703,263118,1004387,437991,571806,7563,43604,439679,28975,817445,435381,639599,504439,713963,527715,500060,588028,94635,231465,767183,757851,424511,387870,607020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]