SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42173 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42173 [ RunTime:0.002368s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489715,394238,398174,42696,455804,414981,993642,819738,12815,36199,505890,63770,49056,541923,893428,567335,18516,616357,819728,768662,452821,890881,13894,185496,855774,744498,968151,75617,703470,854766,945578,730114,625544,850707,540949,512675,985102,536805,998979,26968,277579,345707,35763,845275,625338,1022353,443409,1033036,524814,1033337,62888,782101,26006,426140,987767,785840,913394,763147,690778,362357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]