SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385023 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385023 [ RunTime:0.002515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564835,744059,122447,564669,125680,699168,625849,940845,947475,1004786,490158,204755,689062,294343,903399,496251,705822,599148,544072,1046150,431649,374331,908480,65420,968191,164804,784913,219872,528170,415813,431837,96493,69690,227959,354746,139019,474444,142385,430492,854589,597604,303,964254,312701,1024008,189427,46920,123818,889096,509226,935977,722116,898651,969492,706383,838744,713643,1017433,736995,365354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]