SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341490 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341490 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243491,234139,252684,188319,610403,456461,358268,334170,693967,668895,515575,67009,896646,912509,182291,980266,25988,679514,693668,815557,1039938,592466,410771,402117,426247,350104,231972,241621,106072,204631,497412,758197,616167,146354,770379,526450,1021803,825261,176234,573140,932006,589294,449016,282841,139517,998920,235635,448064,1000672,907045,716341,907064,310034,895913,63560,130897,1037456,669392,604538,34540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]