SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46450 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46450 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117763,1037103,402027,930299,237035,889595,594634,755222,300011,4217,913518,1736,325037,239599,578967,780500,779985,906691,19779,489332,1022754,977382,792085,309980,82562,469742,166117,809072,719437,956481,97185,189451,670783,574859,741639,570579,270363,164153,145211,812813,103738,939504,240433,96629,790954,995415,722211,706353,140527,727884,60003,405321,1037834,713950,1039610,368617,505082,508185,338619,964127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001066s ]