SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564930 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564930 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379563,342606,164180,856698,707037,726035,282797,47156,671018,717503,242945,723566,67172,670049,1029143,37748,153943,144897,200508,434877,408600,839041,538335,459981,435859,579326,835329,665548,1013684,237215,547536,119546,93178,783634,761964,1021121,669792,697050,667986,323777,74525,5187,923356,697096,837962,609742,1037705,635174,458895,645202,959995,1041722,977604,118267,142586,579874,825241,223968,924205,486568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]