SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037736 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037736 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407258,239380,146190,638156,47149,804116,682505,221051,598407,621400,929888,423386,900358,572785,258765,430592,693194,813331,401491,326347,997670,628439,321297,918936,908148,767337,898969,621300,480981,865699,982237,786057,727088,597726,774476,663602,113752,979941,195129,91488,890360,227623,405800,131072,139071,979872,910484,313978,133322,935474,80797,286437,796140,622019,551132,310525,1022933,316164,660853,1003872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002785s ]