SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108312 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108312 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929966,479477,548047,26124,942926,570048,14200,748349,1018228,957839,256091,691652,162019,109458,277159,258466,19797,286753,409423,421233,660135,283239,377133,718571,672048,346423,541670,866160,981211,516328,164705,243882,392200,466991,454150,696537,733125,645434,862344,208416,560299,422038,692887,574939,677631,838425,736122,379485,512942,13132,719765,5209,637667,791105,311148,301943,658722,731357,867202,1027968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]