SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521990 LIMIT 1 [ RunTime:0.003599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521990 [ RunTime:0.002884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955706,1032974,497434,1028491,272205,15518,817330,831799,478822,929861,244455,438554,500166,872580,25317,687320,1043717,170218,178429,152644,817300,131613,841648,400378,523596,985804,67640,402805,634318,506127,966861,807480,583807,328758,106809,841457,861701,491112,618570,946766,710000,1536,670360,711264,183932,459785,750285,292391,274553,773740,800937,952011,497118,705842,112676,98601,391075,731425,167974,213839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]