SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531352 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531352 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476088,676589,137989,263434,403675,44190,1037084,785449,819743,479934,14983,560769,83329,135765,708873,911733,588521,127657,770791,464989,733638,956368,945333,258162,969344,445600,462785,433125,273558,731223,405898,435577,559554,454938,575393,318534,885343,422742,82280,499585,723044,556349,188822,63449,1035768,317418,460513,55034,533651,1016110,344720,351343,502358,874594,975445,865182,295835,119194,1037570,944372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]