SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291551 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291551 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818279,622009,45168,377937,446038,108478,1013678,1040170,431977,1006912,840605,619938,477200,473373,623494,803984,326866,928976,781546,973149,536797,190207,619947,461012,236917,921748,1006838,119074,713093,291598,586738,945653,622144,2926,454771,232085,908423,163083,1026302,562023,315669,1041599,344680,71208,486459,405041,556157,1001878,316026,638548,758430,626267,803454,840996,91925,22250,846555,48699,413334,530267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]