SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044311 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044311 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307104,990529,137138,620108,607085,484245,542444,980114,418077,51490,646721,931780,783774,545578,1001854,648081,509720,374499,280814,305985,456423,653259,998849,268141,507225,795782,770514,271205,103008,235590,517608,879604,708933,651650,229842,806180,565513,669205,197509,589386,1029641,669820,614227,493811,144987,430873,548345,577852,531108,42455,79220,779843,235658,192640,977577,116896,738891,978809,606374,492253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]