SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489746 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489746 [ RunTime:0.005795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678040,365635,784667,888729,692382,506026,799676,232896,445598,970221,831362,792897,748031,397678,874605,477475,291936,732896,709968,151143,342958,1005509,1036913,441536,993826,152764,423687,522497,101381,750793,662538,709082,548445,15794,328362,663875,23892,529939,828479,863955,228456,302172,541357,649969,496294,468939,699306,813287,210488,650705,765270,606505,705476,702181,473127,990248,95238,185872,807670,579836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]