SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401010 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401010 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463521,617272,24241,18147,961283,311861,268893,852954,11525,418166,470113,379660,1041188,936916,803975,843810,44997,697651,639261,751264,563905,303544,115932,750536,62512,239087,191385,817172,549323,876633,891421,597591,73295,846024,934604,44533,850650,225680,102459,719160,628940,15025,812598,323561,777834,382232,560612,594385,151785,147438,362023,951758,321943,29958,873122,943908,485443,277594,501306,219520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]