SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4858 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4858 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944043,1028417,876741,1016811,1044394,355708,561707,426944,263090,739228,93713,45882,548800,722783,509773,266193,87750,956278,682119,138756,832830,10139,112311,244892,451326,419316,545345,944027,347886,667313,34373,337111,851484,171135,97736,379414,311599,495591,414195,356299,1024050,723416,166628,482661,764686,793577,716099,311857,1020661,287939,497662,528800,92715,66384,892026,484110,632063,553473,728472,48113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]