SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485422 LIMIT 1 [ RunTime:0.002558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485422 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519334,834660,514230,926536,258706,222537,594895,850527,165322,1028010,483593,751499,688134,631318,156765,317255,518262,1006535,594691,635203,43845,1014150,459104,496453,890498,282487,716873,1010743,149579,790009,844787,532837,955965,973335,471958,271775,122268,937048,89295,939179,311453,148982,602584,924521,989013,261871,87700,446429,1013708,702997,302260,325555,842769,943527,529402,11758,612334,346361,17522,512512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]