SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015071 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015071 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982803,856335,1350,944349,290560,735609,122905,517064,1024670,23855,129745,717108,99721,551738,801930,903202,367467,161400,564143,199019,692234,225650,1027005,493946,119234,382162,1046782,336148,297175,749762,640676,519467,134512,982071,156664,10557,749620,687224,83648,1003848,39426,778269,892029,200722,778328,489446,673148,1039650,1014826,27927,141516,617640,892552,286008,572468,669117,515805,969819,509585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]