SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805064 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805064 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44018,84809,1021515,660807,594178,900432,445600,839566,254919,261727,788152,127455,960530,612872,748979,394687,501854,371752,133873,507710,163101,676943,152637,507477,79178,138315,400312,735330,186915,246775,400748,815542,832213,282770,382956,457455,897476,450541,107542,97313,781287,497119,455980,559493,955988,460816,800348,379951,397771,129496,861000,123853,758869,196461,544296,307204,479360,1048808,1047226,606832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]