SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596796 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596796 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301273,693923,602666,792375,551821,579418,82635,90075,56112,128409,641587,155930,320022,70450,483306,251380,118105,748253,470546,935109,730010,235459,317206,449496,635759,267232,59882,200975,12426,224539,747368,321312,697630,470167,855256,863376,246778,170537,416751,590048,929805,571468,834376,17472,1016708,82508,994425,463799,430416,96951,907394,154764,711726,282817,234474,540031,882684,448861,867142,774570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]