SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280190 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280190 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511701,706135,1032995,941509,482905,858290,428797,450412,405479,669852,463786,494503,322158,1021652,175208,928367,34199,15968,341110,824838,358009,232169,232756,967491,990652,416740,463376,626219,663110,63549,315130,212633,687179,571548,941996,880147,973111,834633,280159,457677,834055,554783,185711,797400,35069,688895,319662,198739,262607,539012,700544,890031,824357,216009,328422,996086,135699,440294,64377,627985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]