SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506887 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506887 [ RunTime:0.002801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67404,767077,796770,62434,234093,228829,49509,159947,319340,350293,683222,28356,637672,215220,480642,34923,690865,481187,481023,554405,43602,582132,17489,805664,76560,349170,757362,840190,292919,720330,682462,926063,202216,1046487,774003,265115,650745,713663,839532,130384,394689,33576,926415,889328,617147,161967,680859,808778,272499,302977,241336,284578,974063,810736,54212,52850,131077,305091,859761,893407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]