SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199801 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199801 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820705,691128,669245,923959,831894,905963,563371,518082,1004976,397033,303621,354563,607135,539335,299437,811572,361521,787461,948645,16449,251849,1036073,722133,806715,760216,230653,295638,968878,70232,189633,515098,283763,789827,652898,40987,783511,287415,533857,343372,734485,410791,827259,107933,991985,944902,250828,893282,197022,562833,522590,868887,11749,159099,206479,163141,755928,242683,124102,787257,455709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]