SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539405 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539405 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986199,107775,795378,743106,905069,919083,671357,711143,340647,645233,978844,174878,35577,1012073,1034844,602412,479770,796690,581302,877456,331793,241719,5792,489775,402586,185287,713760,300985,817604,195573,957729,125595,142228,393504,610573,1020050,622891,752588,754550,860715,990927,613609,762847,654166,425435,820214,215072,586312,457199,142780,711051,987463,67361,45792,573282,89953,366260,129323,131639,81283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]